﻿CREATE TABLE [dbo].[customers] (
    [ID]          INT           IDENTITY (1, 1) NOT NULL,
    [Corporation] VARCHAR (100) NULL,
    [RealName]    VARCHAR (30)  NOT NULL,
    [Address]     VARCHAR (300) NOT NULL,
    [Mobile]      VARCHAR (20)  NOT NULL,
    [CType]       INT           NOT NULL,
    [Pinyin]      VARCHAR (100) NULL,
    [SortIndex]   INT           CONSTRAINT [DF_customers_SortIndex] DEFAULT ((0)) NOT NULL,
    [Status]      INT           CONSTRAINT [DF_customers_Status] DEFAULT ((1)) NOT NULL,
    [CustomerNo]  VARCHAR (50)  NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);







